A Web-Based Environment for Learning Normalization of Relational Database Schemata
نویسندگان
چکیده
Database normalization is a technique for designing relational database tables to minimize duplication of information in order to safeguard the database against certain types of logical or structural problems, namely data anomalies. Therefore database normalization is a central topic in database theory, and its correct understanding is crucial for students. Unfortunately, the subject it is often considered to be dry and purely theoretical and is often not well received by students. A web-based environment for learning normalization of relational database schemata is developed to give students an interactive hands-on experience in database normalization process. It also provides lecturers with an easy way for creating and testing assignments on the subject. The environment is suitable for relational database and design and data management courses. This report describes the design and development of LDBN (Learn DataBase Normalization) a reference implementation of the learning environment. It also discuss problems that lie within educational and web-based software development.
منابع مشابه
Visualization of Functional Dependencies in a Web Environment
As the core of a previous thesis, a Web-based tool, called LDBN(Learn DataBase Normalization), was developed. The purpose of this tool is to provide an interactive learning environment for the normalization of relational database schemata whose constraints are defined by functional dependencies (FDs). During the fall terms of 2008 and 2009, LDBN was used in conjunction with the course Principle...
متن کاملA Web-based Tool to Enhance Teaching/learning Database Normalization
It has been difficult to motivate students to learn database normalization because students think the subject dry and theoretical. A web-based tool is developed to give students an interactive hands-on experience in database normalization process. The tool is suitable for relational data modeling in systems analysis and design and data management courses. This paper describes the web-based tool...
متن کاملNF-SS: A Normal Form for Semistructured Schema
Semistructured data is becoming increasingly important for web applications with the development of XML and related technologies. Designing a “good” semistructured database is crucial to prevent data redundancy, inconsistency and undesirable updating anomalies. However, unlike relational databases, there is no normalization theory to facilitate the design of good semistructured databases. In th...
متن کاملMapping of SQL Relational Schemata to OWL Ontologies
A novel approach is proposed. This approach maps a relational database defined by a relational schema to an ontology. The ontology has a hierarchical structure, and it is no longer “impaired” by optimization and bad database design of the relational schema. The approach can be used for migrating HTML pages (especially those that are dynamically generated from a relational database) to the ontol...
متن کاملKernel-based distances for relational learning
In this paper we present a novel and general framework for kernel-based learning over relational schemata. We exploit the notion of foreign keys to perform the leap from a flat attribute-value representation to a structured representation that underlines relational learning. We define a new attribute type which builds on the notion of foreign keys that we call instance-set. It is shown that thi...
متن کامل